CREATE EXTERNAL TABLE IF NOT EXISTS jms_dwd.dwd_tab_customer_monitor_vips_dt(
sender_area_name                                  String                        COMMENT '区县',
sender_city_name                                  String                        COMMENT '始发城市',
receiver_province_name                            String                        COMMENT '目的地省',
receiver_city_name                                String                        COMMENT '目的地市',
districtprescription                              String                        COMMENT '时效'
)
COMMENT '项目客户监控明细-唯品会'
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dwd.db/external/dwd_tab_customer_monitor_vips_dt'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);